There are several table functions; however, the format of the function call is the same:

• For a table with a single key:

  <table-function>(“<table name>” <value from key> “<column name>”)

• For a table with n keys:

  <table-function>(“<table name>” <value from key 1> 
  <value from key 2> ... <value from key n> “<column name>”)

The <table name> defines the table to search and must be a quoted text string.

The key values can be constants; if so, you must quote the value. On the other hand, if an attribute is being used (such as pipeline.diameter) for the <value from key> variable, do not place it in quotation marks.

table-lookup(“dpar-reducer-properties” pipeline.diameter “length”)

The “<column name>” is the name of the column in the table where the desired information is. The column name must be contained in quotation marks.

The function call:

table-lookup(“dpar-sample-cost-factors” “304L SS” “costfactor”)

will yield an output of 3.44.

Partial listing of pipe-rating-properties.

The function call:

table-round(“dpar-pipe-rating-properties” 	150 	20.0  “flange-od”)

will yield an output of 88.9.

The function call:

table-lookup(“dpar-sample-cost-factors” pipeline.material 
“cost-factor”)

will look up the cost-factor associated with the type of material.

The function call:

table-lookup(“dpar-sample-cost-factors” 
(table-lookup(“dpar-pipe-class-properties” pipeline-segment.class “material”) “cost-factor”)

will look up the cost-factor associated with the type of material found in the pipe-classproperties table.